package com.system.dao;

import com.system.pojo.DepartmentSalary;

import java.util.List;
import java.util.Map;

/**
 * Created by 陈文杰 on 2022/6/6 14:57
 */
public interface DepartmentSalaryMapper {
    //查询所有部门工资
    List<DepartmentSalary> queryDepartmentSalaryAll();

    //根据部门工资id查询部门工资
    DepartmentSalary queryDepartmentSalaryByDeptSalId(int deptSalId);

    //根据部门名称查询部门工资
    DepartmentSalary queryDepartmentSalaryByDeptName(String deptName);

    //根据部门工资id修改部门工资
    int updateDepartmentSalaryByDeptSalId(Map<String,Object> map);

    //根据部门名称修改部门工资
    int updateDepartmentSalaryByDeptName(Map<String,Object> map);

    //根据部门工资id删除部门工资
    int deleteDepartmentSalaryByDeptSalId(int deptSalId);

    //根据部门名称删除部门工资
    int deleteDepartmentSalaryByDeptName(String deptName);

    //增加部门工资信息
    int addDepartmentSalary(DepartmentSalary departmentSalary);
}
